package edu.cs.usask.ca.silver.persistence.sql;

/**
 * @author Daniel Funk
 * @author Yudi Xue
 * Collection of SQL strings to drop individual tables of the SilverDB interface.
 */
public interface DerbySQLDropTableStringsI {
	
	public static final String DROP_TABLE_MPROJECT = "DROP TABLE MProject";
	
	public static final String DROP_TABLE_MVERSION = "DROP TABLE MVersion";

	public static final String DROP_TABLE_SCENARIOCOLLECTION = "DROP TABLE ScenarioCollection";
		
	public static final String DROP_TABLE_PARAMETERSET = "DROP TABLE ParameterSet";

	public static final String DROP_TABLE_PARAMETER = "DROP TABLE Parameter";

	public static final String DROP_TABLE_P2PS = "DROP TABLE P2ps";

	public static final String DROP_TABLE_SCENARIO = "DROP TABLE Scenario";

	public static final String DROP_TABLE_FILE = "DROP TABLE File";

	public static final String DROP_TABLE_INPUTFILES = "DROP TABLE InputFiles";

	public static final String DROP_TABLE_TRAJECTORYFILES = "DROP TABLE TrajectoryFiles";

	public static final String DROP_TABLE_ANALYSISFILES = "DROP TABLE AnalysisFiles";
	
	public static final String DROP_TABLE_SC2F = "DROP TABLE SC2F";
	
	public static final String DROP_TABLE_MP2F = "DROP TABLE MP2F";
	
	public static final String DROP_TABLE_S2F = "DROP TABLE S2F";
	
	public static final String DROP_TABLE_MV2F = "DROP TABLE MV2F";
	
	public static final String DROP_TABLE_USER = "DROP TABLE SUser";
	
	public static final String DROP_TABLE_GROUP= "DROP TABLE SGroup";
	
	public static final String DROP_TABLE_U2Group = "DROP TABLE U2Group";
	
	public static final String DROP_TABLE_LOG_CHANGESET = "DROP TABLE ChangeSet";
	
	public static final String DROP_TABLE_COMMENT = "DROP TABLE Comment";
	
//	public static final String DROP_TABLE_U2MV = "DROP TABLE U2Mv";
//	
//	public static final String DROP_TABLE_U2SC = "DROP TABLE U2Sc";
//	
//	public static final String DROP_TABLE_U2S = "DROP TABLE U2Scenario";

	public static final String DROP_MVORIGINALSCENARIOCONSTRAINT = "ALTER TABLE MVersion DROP CONSTRAINT mv_original_s_fkey";

	public static final String DROP_MVBASELINESCENARIOCONSTRAINT = "ALTER TABLE MVersion DROP CONSTRAINT mv_baseline_s_fkey";

	public static final String DROP_MVSOURCEFILECONSTRAINT = "ALTER TABLE MVersion DROP CONSTRAINT mv_sourceFile_fkey";
	
	public static final String DROP_ADDUSERPRIVATEGROUPCONSTRAINT = "ALTER TABLE SUser DROP CONSTRAINT u_group_ID_fkey";
}
